翻訳と辞書
Words near each other
・ Declaration on the Granting of Independence to Colonial Countries and Peoples
・ Declaration on the Protection of Women and Children in Emergency and Armed Conflict
・ Declaration on the Rights of Disabled Persons
・ Declaration on the Rights of Indigenous Peoples
・ Declaration on the Status and Name of the Croatian Literary Language
・ Declaration recognising the Right to a Flag of States having no Sea-coast
・ Declaration to the Seven
・ Declarationism
・ Declarations of independence of Vietnam
・ Declarations of war by Great Britain and the United Kingdom
・ Declarations of war during World War II
・ Declarative
・ Declarative learning
・ Declarative memory
・ Declarative programming
Declarative Referential Integrity
・ Declarator
・ Declaratory Act
・ Declaratory Act 1719
・ Declaratory judgment
・ Declaratory power
・ Declare
・ Declare a New State!
・ Declare Guerra
・ Declare Independence
・ Declare the chair vacant
・ Declare Yourself
・ Declared death in absentia
・ Declared monuments of Hong Kong
・ Declared net capacity


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

Declarative Referential Integrity : ウィキペディア英語版
Declarative Referential Integrity
Declarative Referential Integrity (DRI) is one of the techniques in the SQL database programming language to ensure data integrity.
== Meaning in SQL ==
(詳細はforeign key. The referenced column(s) in the parent table must be under a unique constraint, such as a primary key. Also, self-references are possible (not fully implemented in MS SQL Server though). On inserting a new row into the child table, the relational database management system (RDBMS) checks if the entered key value exists in the parent table. If not, no insert is possible. It is also possible to specify DRI actions on UPDATE and DELETE, such as CASCADE (forwards a change/delete in the parent table to the child tables), NO ACTION (if the specific row is referenced, changing the key is not allowed) or SET NULL / SET DEFAULT (a changed/deleted key in the parent table results in setting the child values to NULL or to the DEFAULT value if one is specified).

抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「Declarative Referential Integrity」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.